# test_interfaces_datas = ({'interface_data': {'interfaces_id': 1, 'api': '/znorder-biz/api/order/regist', 'method': 'POST', 'param_data': '{"accountName": "", "accountNo": "", "accountSign": "", "cardNo": "", "cardType": "", "currency": "", "email": "", "interBankFlag": "", "isOther": "", "merchantName": "", "merchantNo": "", "merchantType": "", "orderAmt": "", "orderNo": "1881114784", "orderNum": "", "orderType": "", "smsNotify": ""}', 'header_key': {'Content-Type': ''}, 'interfaces_encryption_url': 'http://192.168.16.52:19090/rsa/encrypt', 'interfaces_decrypt_url': 'http://192.168.16.52:19090/rsa/deencode', 'interfaces_authentication': '1'}},
# [['accountName', '0', '0', ''], ['accountNo', '0', '0', ''], ['accountSign', '0', '0', ''], ['cardNo', '0', '0', ''], ['cardType', '0', '0', ''], ['currency', '0', '0', ''], ['email', '0', '0', ''], ['interBankFlag', '0', '0', ''], ['isOther', '0', '0', ''], ['merchantName', '0', '0', ''], ['merchantNo', '0', '0', ''], ['merchantType', '0', '0', ''], ['orderAmt', '0', '0', ''], ['orderNo', '0', '1', '0'], ['orderNum', '0', '0', ''], ['orderType', '0', '0', ''], ['smsNotify', '0', '0', '']],
# ['Content-Type'])
#
# param_key_dict = {}
#
# for n in test_interfaces_datas[1]:  #['accountName', '0', '0', '']
#     if n[2] == "0":#无随机数，数据库取值
#         testcases_param_values = list(Interface_Case_Param.objects.filter(Interface_Cases_id=testcase_id, param_key=n[0]).values('param_value'))
#         param_key_list = []
#         for i in n:
#             param_key_list.append(i)
#         param_key_list.append(testcases_param_values[0]['param_value'])
#         print(param_key_list)
#         if param_key_list[1] == "0":
#             param_key_dict[param_key_list[0]] = param_key_list[4]
#         elif param_key_list[1] == '3':
#             param_key_dict[param_key_list[0]] = eval(param_key_list[4])
#
#
#
#     elif n[2] == "1":
#         random_values = eval(test_interfaces_datas[0]['interface_data']['param_data'])[n[0]]
#         print(type(random_values))
#         param_key_dict[n[0]] = random_values
#         print("111")
#
# print("测试案例id=%s的测试用例入参值为%s" % (testcase_id, param_key_dict))

# from execute.models import *
# testcase_id = 2
# testcases_case_type = list(Interface_Cases.objects.filter(id=testcase_id).values('case_type'))[0]['case_type']
# type(testcases_case_type)

#
# from Common.Common_random import *
# a = random_addr()[1]
# b = getRandomIdCard()
# c = RandomEmail()
# d = phoneNORandomGenerator()
# print(d)


# import asyncio
#
# async def t():
#     await asyncio.create_subprocess_exec
#     asyncio.create_subprocess_shell

sheet_name = ['Sheet1', 'Sheet2', 'Sheet3']
for i in sheet_name:
    sheet1 = book.sheet_by_name(i)



















